| |
308 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 21 January 2002 21:12 «»
By: Satish Shrikhande
Re: Using create ... in trigger
Use the following statement
in your row level trigger this will create a user satish with password satish .
Only for oracle 8i , if you are working on 7.3 or 8 , use dbms_sql package
execute immediate 'create user satish identified by satish ';
|
| 2 |
Forum: Linux «»
Posted on: Tue, 28 April 2015 06:05 «»
By: satish590
trying to connect host port 22..connection refused
Hi,
when i connect to server from client host it is showing conection refused
i gave this command
ssh -X oacle@192.168.1.100
o/p
ssh: connect to host 192.168.1.100 port 22 connection refused
please help me to resolve this issue
Regards,
Satish
|
| 3 |
Forum: Linux «»
Posted on: Mon, 03 November 2014 00:06 «»
By: Littlefoot
Re: Oracle linux
…I presumed that "dracut" must be Satish's typo. It never occurred to me that it has anything to do with an IT term.
Therefore, apologies to Satish & the community. I'll try to correct my behaviour (can't promise I'll succeed).
…
|
| 4 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 01 September 2014 03:53 «»
By: satishvaka
CHMOD FROM A PLSQL?
Hello, how I can run a chmod from a plsql block? if they can help me please ..
Regards
Satish Vaka
|
| 5 |
Forum: Reports & Discoverer «»
Posted on: Wed, 15 May 2013 15:59 «»
By: jay_cooldude
layout
… 15000
SUBBU 9000
SATISH 10000
VIKRAM 8000
JUNID SALES 3000
JACKSON 12000
AMITH 5000
[b]ACTUAL OUTPUT[/b]
NAME DEPARTMENT…
|
| 6 |
Forum: Performance Tuning «»
Posted on: Mon, 19 March 2012 02:31 «»
By: msol25
Re: TABLESPACE EXTENT
Hi Satish,
Please execute query:
select sum(bytes)/1048576 "Size in Mb"
from user_segments
where segment_name = 'TABLE_NAME';
Thanks
|
| 7 |
Forum: Streams & AQ «»
Posted on: Tue, 19 July 2011 22:04 «»
By: ssgottik
Re: Oracle Streams - coming with hex value in target system
…much about triggers ( provided source and target schema structure are same).
Below link may be useful for you
gssdba.wordpress.com/2011/04/20/steps-to-implement-schema-level-oracle-streams/
Thanks and Regards,
Satish.G.S
gssdba.wordpress.com…
|
| 8 |
Forum: Streams & AQ «»
Posted on: Tue, 19 July 2011 21:37 «»
By: ssgottik
Re: NEW ORACLE STRAMS CONFIG
Below link may be useful:
gssdba.wordpress.com/2011/04/20/steps-to-implement-schema-level-oracle-streams/
Thanks and Regards,
Satish.G.S
gssdba.wordpress.com
|
| 9 |
Forum: Streams & AQ «»
Posted on: Tue, 19 July 2011 21:20 «»
By: ssgottik
Re: Oracle Streams
…offen you use to get ORA-01403 NO DATA FOUND error, below link may be useful for you to trouble shoot the above issue.
gssdba.wordpress.com/2011/05/09/ora-01403-no-data-found-in-oracle-streams/
Thanks and Regards,
Satish.G.S
gssdba.wordpress.com…
|
| 10 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 February 2011 23:02 «»
By: satishwithoracle
Meaning of operator
…
the testify is procedure. answer is BOOLEAN variable
answer := nt1 IN (nt2,nt3,nt4); -- true, nt1 matches nt2
testify(truth => answer);
pl.let me know why above symbol is used. Is it used for pass value or for what ?
Thanks
Satish…
|
| 11 |
Forum: Marketplace «»
Posted on: Sat, 22 January 2011 22:28 «»
By: satishiyer
Oracle DBA 7 to 14 yr on Unix/Linux Pune(Goldengate or Siebel Exp Preffered)
…on performance tuning & Management. Candidate with Goldengate or Siebel exp will be preffered. Pls send mail at satish.iyer.it@gmail.com with subject "Oracle DBA". Also mention your current CTC, Exp CTC, Passport number, Notice period…
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 31 August 2010 03:41 «»
By: Michel Cadot
Re: convert one string into multiple strings
Do you realize that Satish learns how to do it by himself and so now he will be able to manage any other similar case; on the other hand, you will just copy his solution, will you be able to manage futur similar exercises?
Regards
Michel
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 31 August 2010 03:37 «»
By: negishailesh
Re: convert one string into multiple strings
thanx a lot satish,query is working...
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 12 August 2010 03:51 «»
By: satishwithoracle
Re: How I can inser all rows values fetched by cursor
Thank you very much for reply. But If There is More Than 10 columns and I want to store all values(10 columns rows) fetched by Cursor without specifying column name.
Is it possible or code so I can insert directly ?
Thanks
Satish
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 12 August 2010 00:33 «»
By: satishwithoracle
How I can inser all rows values fetched by cursor
…with color row as below.
Thanks
Satish
----------------------
DECLARE
CURSOR C1 IS select * from employees;
C2 C1%ROWTYPE;
counter NUmber :=0;
BEGIN
OPEN C1;
LOOP
FETCH C1 INTO C2;
IF C2.SALARY > 10000 THEN
INSERT INTO EMP2 …
|
| 16 |
Forum: Linux «»
Posted on: Tue, 10 August 2010 03:22 «»
By: satishwithoracle
virtual Server configuration in Linux
…edittion. I tried to installed and generated ./vmware.pl
But I am getting error and I could not get graphics mode to install guest operating system
Kindly pl. provide step . How can I install and configure Oracle VM server.
Thanks
Satish…
|
| 17 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 04 August 2010 00:36 «»
By: ramoradba
Re: thread
@ satish
OP already posted 49 messages so there is no such "Unfair"
sriram
|
| 18 |
Forum: Business Intelligence «»
Posted on: Tue, 20 April 2010 17:16 «»
By: SatishkGoud
Writeback Option in OBIEE
… Next time he runs the report, the record that he checked last time will not appear in the exception report this is because she has already reviewed it and deemed it a valid record.
Let me know if anyone has workaround for this...
Thank You
…
|
| 19 |
Forum: Business Intelligence «»
Posted on: Tue, 09 March 2010 11:53 «»
By: SatishkGoud
Clustered OBIEE Servers
Guys
Had anyone expertise in how to Configure the BI Server to be clustered in OBIEE.
Thank You
Satish
|
| 20 |
Forum: Business Intelligence «»
Posted on: Mon, 01 March 2010 16:40 «»
By: SatishkGoud
Any one tried Installing OBIEE on Windows 7 Proffesional
Experts
Had anyone tried on Installing Obiee on Windows Proffesional 7.
Thanks & Regards
Satish
|
| 21 |
Forum: Business Intelligence «»
Posted on: Mon, 01 March 2010 16:06 «»
By: SatishkGoud
Re: Variables in OBIEE
Seema
Did you get any good doc on this ....
Thank YOu
satish
|
| 22 |
Forum: Business Intelligence «»
Posted on: Mon, 01 March 2010 14:42 «»
By: SatishkGoud
Odbc driver returned an error (SQLExecDirectW
…t; saw_8 FROM "CSW - LIVE - Class Enrollment" WHERE (Class."Term Description" = 'Fall 2010') AND (Class."Class Type" = 'E') ORDER BY saw_0, saw_1, saw_2, saw_3, saw_4, saw_5, saw_6, saw_7, saw_8
Thank YOu
Satish…
|
| 23 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Wed, 24 February 2010 07:43 «»
By: hysat429
using occi in external XA applications and/or in pro*c/c++
…acquired OCCI api's.
In our case as tuxedo is creating and maintaing the connects how to use the OCCI api's ?
Can we get the existing connection taken from the tuxedo and use to call the OCCI api's ?
any suggestions ?
Thanks in advance
satish…
|
| 24 |
Forum: Business Intelligence «»
Posted on: Tue, 06 October 2009 12:57 «»
By: ramsatish
integration services options in oracle
Hi All,
Do we have integration services option in Oracle, Like we have SQL Server integration Services?
I am working on Oracle 11g
Thanks....
Sriram Satish
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 01 October 2009 05:10 «»
By: JRowbottom
Re: Can this be possible through sql ?
…test_074 values ('15179SE','KULKARNI, Mr. SATISH C.');
insert into test_074 values ('UDP2376','PANDIT, Mr. ULHAS D.');
insert into test_074 values ('JSI4391','INAMDAR, Mr. JAINUDDIN S.');
insert into test_074 values ('SAJ8332','JOSHI, Mr. SHRINIWAS A…
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 01 October 2009 04:18 «»
By: bryanadams
Re: Can this be possible through sql ?
…
insert into users('15179SE','KULKARNI, Mr. SATISH C.');
insert into users('UDP2376','PANDIT, Mr. ULHAS D.');
insert into users('JSI4391','INAMDAR, Mr. JAINUDDIN S.');
insert into users('RDN10163ME','Nandkhile, Mr. R. D. (CORP)');
insert into users('…
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 01 October 2009 04:15 «»
By: JRowbottom
Re: Can this be possible through sql ?
…test_074 values ('15179SE','KULKARNI, Mr. SATISH C.');
insert into test_074 values ('UDP2376','PANDIT, Mr. ULHAS D.');
insert into test_074 values ('JSI4391','INAMDAR, Mr. JAINUDDIN S.');
insert into test_074 values ('SAJ8332','JOSHI, Mr. SHRINIWAS A…
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 01 October 2009 03:54 «»
By: bryanadams
Can this be possible through sql ?
…Name [/b]
15179SE KULKARNI, Mr. SATISH C.
UDP2376 PANDIT, Mr. ULHAS D.
JSI4391 INAMDAR, Mr. JAINUDDIN S.
SAJ8332 JOSHI, Mr. SHRINIWAS A.
RDN10163ME Nandkhile, Mr. R. D. (CORP)
UGJ7894SE JOSHI, Mr. UDAY GAJANAN
…
|
| 29 |
Forum: Performance Tuning «»
Posted on: Wed, 05 August 2009 07:40 «»
By: satish2130
Re: FTS - Full Table Scan -
…
Is there any negative impact on the other jobs if they are running simultaneously??
Is there any chance to increase the buffer size/Temporary Segement for this Query or anything else?
Please let me know your valuable suggestions,
Thanks,
Satish…
|
| 30 |
Forum: Performance Tuning «»
Posted on: Wed, 05 August 2009 07:07 «»
By: satish2130
Re: FTS - Full Table Scan -
…from 9i to 10g.
I have taken up this database support recently.
What is the impact if we use this optimzer hint opt_param for altering the INIT parameter default values.
Pleae let me know if you have any updates on this..
Thanks,
Satish…
|
| 31 |
Forum: Performance Tuning «»
Posted on: Wed, 05 August 2009 06:49 «»
By: satish2130
Re: FTS - Full Table Scan -
…are some issues on the production. we are still keep 9i optimizer in the Oracle 10g.
I would like to know the best reponse time using FTS.
is there any hints for FTS to get better performance?
Plz. provide any suggestion.
Thanks,
Satish…
|
| 32 |
Forum: Performance Tuning «»
Posted on: Wed, 05 August 2009 06:44 «»
By: satish2130
Re: FTS - Full Table Scan
…not use the index because the statement returns more than 60%. The selectivity is more.
I need to complete this statement execution < 8 Min's
Could you please provide any other solutions?
Thank you in advance.
Thanks and Regards,
Satish…
|
| 33 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Tue, 21 July 2009 02:23 «»
By: satishdusane
Oracle Apps Training for Functional ?
…Everyone ,
This is Satish, and pursuing my current job in ERP. But I want to boost up my carrer in Oracle Apps. Thats why looking for any Oracle Apps Training Institute for Functional. So, anyone can suggest me Oracle Apps Training Institutes in Pune, …
|
| 34 |
Forum: Training & Certification «»
Posted on: Wed, 24 June 2009 05:35 «»
By: satishts@idsin.net
Re: ERP Courses
…offers Certification Training from Oracle University, which is having the global value
For more details on training and certification contact undersigned
Thanks and Regards,
Satish T S
0091 80 41316697
0091 99029 88773
satishts@idsin.net…
|
| 35 |
Forum: Training & Certification «»
Posted on: Wed, 24 June 2009 04:57 «»
By: satishts@idsin.net
Re: SQL & PL/SQL Certifications
…Approved Education Center offering the Oracle Certification trainings in association with Oracle University.
Pls contact undersigned for more details
Thanks and Regards,
Satish T S
0091 80 41316697
0091 99029 88773
satishts@idsin.net…
|
| 36 |
Forum: Server Administration «»
Posted on: Fri, 19 June 2009 08:28 «»
By: satish_j
Re: connected to Idle Instance
Thank you michel..you answered all my queries..i understood now the startup process on oracle
Thanks,
Satish
|
| 37 |
Forum: Performance Tuning «»
Posted on: Fri, 01 May 2009 15:05 «»
By: satishnawle
Re: Query Slow
please check you query if your using index , please use hint also in you query . You need to analyze table and indexes
Satish
|
| 38 |
Forum: Backup & Recovery «»
Posted on: Fri, 01 May 2009 14:59 «»
By: satishnawle
Re: how to know the DBID ?
Dear
There is no need to set DB ID , just connect to target database and fire RMAN>restore controlfile otherwise RMAN>restore controlfile from '.snap ' file location file is present on oracle_home/dbs
Satish Nawle
+919222130789
|
| 39 |
Forum: Server Administration «»
Posted on: Fri, 01 May 2009 14:52 «»
By: satishnawle
Re: excessive archive log are generating by oracle
Dear
if set archive_lag_target parameter then change value of that parameter else there same problem with application code
Satish Nawle
9222130789
|
| 40 |
Forum: Forms «»
Posted on: Mon, 13 April 2009 23:47 «»
By: satishwithoracle
MMB compiled in version 9.0 not wotking in forms6i
… in new version and FRM-10221 cannot read file .mmx
I uploded my file when I trying to compile in 6i than I am getting error.
KIndly guide me how can I Compile my Menu file in developer 9 and it can run in developer 6.
Thanks
SATISH…
|
Blog
Search
Help
Members
Register
Login
Home